syStudent

Logical Entity Name | syStudent
Default Table Name | syStudent
Physical Only | NO
Owner | dbo
Definition |
Note |

syStudent Columns

ColumnName | Domain | Datatype | NULL | Definition
SSN |  | varchar(30) | YES |
AmTitleID |  | int | NO |
LastName |  | varchar(128) | YES |
FirstName |  | varchar(128) | YES |
NickName |  | nvarchar(50) | NO |
MaidenName |  | nvarchar(50) | NO |
Addr1 |  | varchar(255) | NO |
Addr2 |  | char(1) | YES |
City |  | varchar(25) | NO |
State |  | char(2) | NO |
Zip |  | char(10) | NO |
BadAddr |  | bit | NO |
SyCountryID |  | int | YES |
SyCountyID |  | int | NO |
Phone |  | char(16) | NO |
WorkPhone |  | char(16) | NO |
Workext |  | varchar(10) | NO |
BadPhone |  | bit | NO |
LeadDate |  | datetime | YES |
AmLeadTypeID |  | int | NO |
AmSexID |  | int | NO |
AmRaceID |  | int | NO |
AmNationalityID |  | int | NO |
AmMaritalID |  | int | NO |
DrivLicState |  | char(2) | NO |
DrivLic |  | char(20) | NO |
DOB |  | datetime | YES |
AlienNo |  | char(9) | YES |
AmAgencyID |  | int | NO |
AmCitizenID |  | int | NO |
email |  | varchar(128) | NO |
SySchoolStatusID |  | int | NO |
AmRepID |  | int | NO |
AmLeadSrcID |  | int | NO |
SyCampusID |  | int | NO |
AdProgramGroupID |  | int | NO |
AdProgramID |  | int | NO |
AdShiftID |  | int | NO |
StartDate |  | datetime | YES |
AmPrevEducID |  | int | NO |
AmHighSchoolID |  | int | NO |
AmCollegeID |  | int | YES |
HsGradDate |  | datetime | YES |
ARBalance |  | money | NO |
NextTranNum |  | smallint | NO |
ArAcctStat |  | char(2) | NO |
StmtLastDate |  | datetime | YES |
StmtBeginDate |  | datetime | YES |
StmtCloseDate |  | datetime | YES |
StmtComment |  | varchar(200) | NO |
DefaultAddressCode |  | char(1) | YES |
DefaultAddressID |  | int | YES |
PlEmployerID |  | int | NO |
plEmpStatusID |  | int | NO |
StuNum |  | varchar(30) | YES |
PIN |  | numeric(4, 0) | YES |
Comment |  | text | NO |
AmExtraCurrID |  | int | YES |
Active |  | bit | NO |
DataBlockIndicator |  | bit | NO |
ModFlag |  | char(1) | NO |
Userid |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
SyStudentId |  | int | NO |
Disabled |  | char(1) | NO |
Vet |  | char(1) | NO |
OriginalAmRepID |  | int | YES |
CumGPA |  | numeric(11, 6) | YES |
CumGPAPoints |  | money | YES |
CurrentLDA |  | datetime | YES |
GPACredits |  | money | YES |
OriginalStartDate |  | datetime | YES |
OriginalExpStartDate |  | datetime | YES |
OtherPhone |  | char(16) | YES |
OtherEmail |  | varchar(128) | YES |
LastActivityDate |  | datetime | YES |
LastInterestDate |  | datetime | YES |
DefaultMasterAddressID |  | int | YES |
Suffix |  | char(3) | YES |
MiddleName |  | varchar(100) | YES |
NIStudent |  | bit | NO |
StudentIdentifier |  | varchar(200) | YES |
PrevEducGPA |  | numeric(11, 6) | YES |
HSGraduated |  | bit | NO |
HSGraduationSession |  | varchar(10) | YES |
HSDateEnrolled |  | datetime | YES |
HSLastDateAttended |  | datetime | YES |
HSStudRank |  | int | YES |
HSSchoolSize |  | int | YES |
HSTranscriptType |  | tinyint | YES |
HSStudLevel |  | tinyint | YES |
HSGradYear |  | varchar(4) | YES |
LastName_FirstFour |  | varchar(4) | YES |
Zip_FirstThree |  | varchar(3) | YES |
DBIModifiedDate |  | datetime | YES |
BestTimeToContact |  | varchar(10) | YES |
RawLastName |  | varchar(25) | YES |
RawFirstName |  | varchar(25) | YES |
RawPhone |  | varchar(16) | YES |
ACGEligReasonCode |  | char(2) | YES |
FARigorousHighSchoolProgramCodeID |  | int | YES |
CMSMSServiceProviderID |  | int | YES |
SubscribeToSMS |  | bit | NO |
MobileNumber |  | varchar(16) | YES |
SourceSystem |  | char(1) | NO |
IsHispanic |  | char(1) | YES |
CrmSuppressFlag |  | bit | NO |
DDVeteran |  | bit | NO |
HSAcademicGPA |  | numeric(11, 6) | YES |
AmSuffixID |  | int | YES |
AthleticID |  | varchar(20) | YES |
faGradPlusCounselingDate |  | datetime | YES |
InDistrict |  | bit | NO |
DefaultStipendsToEFT |  | bit | NO |
MI |  | AS (isnull(left([MiddleName],(1)),' ')) |  |
SyPersonId |  | int | YES |
PreferredContactType |  | nvarchar(20) | YES |
PreferredName |  | nvarchar(50) | YES |
ExternalStudentIdentifier |  | nvarchar(250) | YES |
SSNLastFourDigits |  | AS (right(rtrim([ssn]),(4))) |  |
IsClearingHouseDBI |  | bit | NO |
FullName |  | AS ((ltrim(rtrim([LastName]))+', ')+ltrim(rtrim(isnull([FirstName],'')))) |  |
SSCRError11Received |  | bit | NO |
PreferredLanguageId |  | int | YES |
SMSSubscriptionStatus |  | int | NO |

syStudent Primary and Unique Keys

Key Name | Key Type | Keys
syStudent_SyStudentID_U_C_IDX | PrimaryKey | SyStudentId
Nk_SyStudent_LastName_NickName_SyStudentID_U_N_IDX | Index | LastName, NickName, SyStudentId
SyStudent_MaidenName_NickName_SyStudentID_U_N_IDX | Index | MaidenName, NickName, SyStudentId
SyStudent_WorkPhone_SyCampusID_SyStudentID_U_N_IDX | Index | WorkPhone, SyCampusID, SyStudentId
SyStudent_Phone_SyCampusID_SyStudentID_U_N_IDX | Index | Phone, SyCampusID, SyStudentId
Nk_SyStudent_MaidenName_NickName_SyStudentID_U_N_IDX | Index | MaidenName, NickName, SyStudentId
syStudent_SyStudentId_Email_U_N_IDX | Index | SyStudentId, email

syStudent Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
amLeadSrc | Non-Identifying | One To Zero or More | FK_syStudent_AmLeadSrcID_AmLeadSrc_AmLeadSrcID |  |  | AmLeadSrcID | NO | YES
CMSMSServiceProvider | Non-Identifying | Zero or One to Zero or More | FK_SyStudent_CMSMSServiceProviderID_CMSMSServiceProvider_CMSMSServiceProviderID |  |  | CMSMSServiceProviderID | NO | YES
SyAddress | Non-Identifying | Zero or One to Zero or More | FK_syStudent_DefaultMasterAddressID_SyAddress_SyAddressID |  |  | DefaultMasterAddressID | NO | YES
FARigorousHighSchoolProgramCode | Non-Identifying | Zero or One to Zero or More | FK_SyStudent_FARigorousHighSchoolProgramCodeID_FARigorousHighSchoolProgramCode_FARigorousHighSchoolProgramCodeID |  |  | FARigorousHighSchoolProgramCodeID | NO | YES
AmSuffix | Non-Identifying | Zero or One to Zero or More | FK_SyStudentAmSuffixID_AmSuffixAmSuffixID |  |  | AmSuffixID | NO | YES
SyPerson | Non-Identifying | Zero or One to Zero or More | FK_SyStudentSyPersonId_SyPersonSyPersonId |  |  | SyPersonId | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AdAttend_Proxy | Non-Identifying | One To Zero or More | FK_AdAttend_Proxy_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
AdEnroll | Non-Identifying | One To Zero or More | FK_AdEnroll_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
AdEnrollSchedStatusChanges | Non-Identifying | One To Zero or More | FK_AdEnrollSchedStatusChangesSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
AdEnrollSchedStatusHistory | Non-Identifying | One To Zero or More | FK_AdEnrollSchedStatusHistory_syStudentID_syStudent_syStudentID |  |  |  | NO | YES
AdEnrollTerm_RebuildRelationshipLog | Non-Identifying | One To Zero or More | FK_AdEnrollTerm_RebuildRelationshipLog_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
AdEnrollTerm | Non-Identifying | One To Zero or More | FK_AdEnrollTerm_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
AdEnrollTermRelationshipException | Non-Identifying | One To Zero or More | FK_AdEnrollTermRelationshipException_syStudentID_syStudent_syStudentID |  |  |  | NO | YES
AdGainfulEmploymentReportingDetails | Non-Identifying | One To Zero or More | FK_AdGainfulEmploymentReportingDetailsSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
AdGPAStudentCourse | Non-Identifying | One To Zero or More | FK_AdGPAStudentCourseSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
AdGPAStudent | Non-Identifying | One To Zero or More | FK_AdGPAStudentSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
AdRegistrationLock | Non-Identifying | One To Zero or More | FK_AdRegistrationLockSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
AdStudentDegreePathway | Non-Identifying | One To Zero or More | FK_AdStudentDegreePathway_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
AdStudentTermSequenceHeader | Non-Identifying | One To Zero or More | FK_AdStudentTermSequenceHeader_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
AdStudentTransferHeader | Non-Identifying | One To Zero or More | FK_AdStudentTransferHeader_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
AmApplicant | Identifying | One To Zero or More | FK_AmApplicant_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
AmCollegeTransfer | Non-Identifying | One To Zero or More | FK_AmCollegeTransfer.SyStudentID_SyStudent.SyStudentID |  |  |  | NO | YES
AmCollegeTransferAdvance | Non-Identifying | One To Zero or More | FK_AmCollegeTransferAdvance_SyStudentId_syStudent_SyStudentId |  |  |  | NO | YES
CmDocument | Non-Identifying | One To Zero or More | FK_CmDocument_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
CmDocumentPermit | Non-Identifying | One To Zero or More | FK_CmDocumentPermitSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
CmFERPADirStudentRelation | Non-Identifying | One To Zero or More | FK_CmFERPADirStudentRelationSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
CmFERPAStudentInfoRequest | Non-Identifying | One To Zero or More | FK_CmFERPAStudentInfoRequestSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
CmIncidentStudent | Non-Identifying | One To Zero or More | FK_CmIncidentStudent.SyStudentID_SyStudent.SyStudentID |  |  |  | NO | YES
CmPreferredContactMethod | Non-Identifying | One To Zero or More | FK_CmPreferredContactMethod_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
CmResidencyStudentRelation | Non-Identifying | One To Zero or More | FK_CmResidencyStudentRelation_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaAwardLetterQueue | Non-Identifying | One To Zero or More | FK_FaAwardLetterQueue_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaCampusVantageWorkStudyPayroll | Non-Identifying | One To Zero or More | FK_FaCampusVantageWorkStudyPayroll_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
FaCorrections00 | Non-Identifying | Zero or One to Zero or More | FK_FaCorrections00_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
FaDefaultRateDetail | Non-Identifying | One To Zero or More | FK_FaDefaultRateDetail_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
FaDelinquentBorrowerDetail | Non-Identifying | One To Zero or More | FK_FaDelinquentBorrowerDetail_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
FaEstimate | Non-Identifying | One To Zero or More | FK_FaEstimate_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
FaEstimateAward | Non-Identifying | One To Zero or More | FK_FaEstimateAward_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
FaEstimateAY | Identifying | One To Zero or More | FK_FaEstimateAY_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
FaFAFSA04 | Non-Identifying | One To Zero or More | FK_FaFAFSA04_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
FaFAFSA08 | Non-Identifying | One To Zero or More | FK_FaFAFSA08_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaFAFSA09 | Non-Identifying | One To Zero or More | FK_FaFAFSA09_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaFAFSA10 | Non-Identifying | One To Zero or More | FK_FaFAFSA10_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaFAFSA11 | Non-Identifying | One To Zero or More | FK_FaFAFSA11_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaFAFSA12 | Non-Identifying | One To Zero or More | FK_FaFAFSA12_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaFafsa | Non-Identifying | One To Zero or More | FK_FaFafsaSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
FaHopeBenchmarkTierEvaluationResult | Non-Identifying | One To Zero or More | FK_FaHopeBenchmarkTierEvaluationResultSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
FaISIRcCode | Identifying | One To Zero or More | FK_FaISIRcCode_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaISIRCorrection | Non-Identifying | One To Zero or More | FK_FaISIRCorrectionSyStudentId_SyStudentSyStudentId |  |  |  | NO | YES
FAISIRMatch | Non-Identifying | One To Zero or More | FK_FAISIRMatch_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaISIRStudentMatch | Non-Identifying | One To Zero or More | FK_FaISIRStudentMatchSyStudentId_SyStudentSyStudentId |  |  |  | NO | YES
FaLoanApplication | Non-Identifying | One To Zero or More | FK_FaLoanApplication_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaMpnInfo_Regulatory | Non-Identifying | One To Zero or More | FK_FaMpnInfo_Regulatory_SystudentId_SyStudent_SyStudentId |  |  |  | NO | YES
FaMultiDisbException | Non-Identifying | One To Zero or More | FK_FaMultiDisbException_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaNSLDSStudent | Non-Identifying | One To Zero or More | FK_FaNSLDSStudent_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaShoppingSheet | Non-Identifying | One To Zero or More | FK_FaShoppingSheet_syStudent |  |  |  | NO | YES
FaStudentAid | Non-Identifying | One To Zero or More | FK_FaStudentAid_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
FaStudentAidCashPlanHistory | Non-Identifying | One To Zero or More | FK_FaStudentAidCashPlanHistory_SyStudent_SyStudentId |  |  |  | NO | YES
FaStudentAutoAwardLog | Non-Identifying | One To Zero or More | FK_FaStudentAutoAwardLog_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
FaStudentDocs | Non-Identifying | One To Zero or More | Fk_FaStudentDocs_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaStudentFAFSA | Non-Identifying | One To Zero or More | FK_FaStudentFAFSASyStudentId_SyStudentSyStudentId |  |  |  | NO | YES
FaStudentFundSource | Non-Identifying | One To Zero or More | FK_FaStudentFundSourceSyStudentId_SyStudentSyStudentId |  |  |  | NO | YES
FaStudentMaster | Non-Identifying | One To Zero or More | FK_FaStudentMaster_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
FaStudentPell | Non-Identifying | One To Zero or More | FK_FaStudentPell_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
FaTsmDetail | Non-Identifying | One To Zero or More | FK_FaTsmDetailSyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaTsmMain | Non-Identifying | One To Zero or More | FK_FaTsmMainSyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
FaVerificationHistory | Non-Identifying | One To Zero or More | FK_FaVerificationHistory_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
HsBuildingRoomsStudents | Non-Identifying | One To Zero or More | FK_HsBuildingRoomsStudents_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
HsRoomMateMatchStudent | Non-Identifying | One To Zero or More | FK_HsRoomMateMatchStudent_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
HsStudentApplication | Non-Identifying | One To Zero or More | FK_HsStudentApplication_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
HsStudentApplicationAnswers | Non-Identifying | One To Zero or More | FK_HsStudentApplicationAnswers_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
HSStudentLeaseHistory | Non-Identifying | One To Zero or More | FK_HSStudentLeaseHistory_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
HsStudentResponseComments | Non-Identifying | One To Zero or More | FK_HsStudentResponseComments_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
PlStudentApplyHist | Non-Identifying | One To Zero or More | FK_PlStudentApplyHist_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
PlStudentInSchool | Non-Identifying | One To Zero or More | FK_PlStudentInSchool_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
PlStudentSearchAgent | Non-Identifying | One To Zero or More | FK_PlStudentSearchAgent_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
Sa1098TBatchDetail | Identifying | One To Zero or More | FK_Sa1098TBatchDetail_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
SaBillingStatementBatchDetailCharges | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchDetailCharges_SyStudentID_SyStudent_SySTudentID |  |  |  | NO | YES
SaBillingStatementBatchDetailFA | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchDetailFA_SyStudentID_SyStudent_SySTudentID |  |  |  | NO | YES
SaBillingStatementBatchDetailPayments | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchDetailPayments_SyStudentID_SyStudent_SySTudentID |  |  |  | NO | YES
SaBillingStatementBatchStudent | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchStudent_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
SaBillingStatementBatchStudentDetail | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchStudentDetail_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
SaBillingStatementBatchSubsidiaryDetail | Non-Identifying | One To Zero or More | FK_SaBillingStatementBatchSubsidiaryDetail_SyStudentID_SyStudent_SySTudentID |  |  |  | NO | YES
SaCollections | Non-Identifying | One To Zero or More | FK_SaCollections_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
SaDisbReceiptNotification | Non-Identifying | One To Zero or More | FK_SaDisbReceiptNotificationSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
SaPaymentApply | Non-Identifying | One To Zero or More | FK_SaPaymentApply_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
SaPendingCharge | Non-Identifying | One To Zero or More | FK_saPendingCharge.SyStudentID_SyStudent.SyStudentID |  |  |  | NO | YES
SaStatementHistory | Non-Identifying | One To Zero or More | FK_SaStatementHistory_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
SaStudentBankAccount | Non-Identifying | One To Zero or More | FK_SaStudentBankAccount_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
SaStudSubsidiaryAdjust | Non-Identifying | One To Zero or More | FK_SaStudSubsidiaryAdjust_syStudentId_syStudent_syStudentId |  |  |  | NO | YES
SsAthleticDetail | Non-Identifying | One To Zero or More | FK_SsAthleticDetailSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
SsStudentDisabilityDetail | Non-Identifying | One To Zero or More | FK_SsStudentDisabilityDetailSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
SsStudentServiceAssociation | Non-Identifying | One To Zero or More | FK_SsStudentServiceAssociation_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
SsStudentVeteranDetail | Non-Identifying | One To Zero or More | FK_SsStudentVeteranDetailSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
SsStudRoommate | Identifying | One To Zero or More | FK_SsStudRoommate_RoommateSyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
SyAudit_AdAttend | Non-Identifying | One To Zero or More | FK_SyAudit_AdAttend_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
SyAudit_AdAttendArchive | Non-Identifying | One To Zero or More | FK_SyAudit_AdAttendArchive_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
SyAudit_AmDeposit | Non-Identifying | One To Zero or More | FK_SyAudit_AmDeposit_RecordId_SyStudent_SyStudentId |  |  |  | NO | YES
SyAudit_AmProspectTest | Non-Identifying | One To Zero or More | FK_SyAudit_AmProspectTest_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
SyAudit_CmDocument | Non-Identifying | One To Zero or More | FK_SyAudit_CmDocument_SyStudentID_SyStudent_SyStudentID |  |  |  | NO | YES
SyAudit_FaStateEligibility | Non-Identifying | One To Zero or More | FK_SyAudit_FaStateEligibilitySyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
SyAudit_SyStudent | Non-Identifying | One To Zero or More | FK_SyAudit_SyStudent_RecordID_syStudent_SyStudentID |  |  |  | NO | YES
SyCornerstoneBatchDetail | Non-Identifying | One To Zero or More | FK_SyCornerstoneBatchDetail_SyStudentID_SyStudent_SyStudentId |  |  |  | NO | YES
SyGPACalculateQueue | Non-Identifying | One To Zero or More | FK_SyGPACalculateQueueSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
SyIndicatorStudentRelation | Non-Identifying | One To Zero or More | FK_SyIndicatorStudentRelation_SyStudentId_syStudent_SyStudentId |  |  |  | NO | YES
SyServiceMessageSourceRecord | Non-Identifying | One To Zero or More | FK_SyServiceMessageSourceRecordSyStudentId_SyStudentSyStudentId |  |  |  | NO | YES
SySEVISBatchDetail | Non-Identifying | One To Zero or More | FK_SySEVISBatchDetail_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
SySEVISChanges | Non-Identifying | One To Zero or More | FK_SySEVISChanges_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
SySEVISSiteOfActivity | Non-Identifying | One To Zero or More | FK_SySEVISSiteOfActivity_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
SyStudentAmRace | Non-Identifying | One To Zero or More | FK_SyStudentAmRaceSyStudentID_SyStudentSyStudentID |  |  |  | NO | YES
SyStudentExternalDMConfiguration | Non-Identifying | One To Zero or More | FK_SyStudentExternalDMConfiguration_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
SyStudentExternalDMIdentifierMap | Non-Identifying | One To Zero or More | FK_SyStudentExternalDMIdentifierMap_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
SyStudentExternalMap | Non-Identifying | One To Zero or More | FK_SyStudentExternalMap_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES
SyStudentExternalMap | Non-Identifying | One To Zero or More | FK_syStudentExternalMapsyStudentId_syStudentsyStudentId |  |  |  | NO | YES
SyStudentNI | Non-Identifying | One To Zero or More | FK_SyStudentNI_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
SyStudentNIDependent | Non-Identifying | One To Zero or More | FK_SyStudentNIDependent_SyStudentID_syStudent_SyStudentID |  |  |  | NO | YES
SyStudentOrganizationContact | Non-Identifying | One To Zero or More | FK_SyStudentOrganizationContact_SyStudentId_SyStudent_SyStudentID |  |  |  | NO | YES
SyStudentResidencyStatus | Non-Identifying | One To Zero or More | FK_SyStudentResidencyStatus_SyStudentId_SyStudent_SyStudentId |  |  |  | NO | YES

syStudent Check Constraints

Check Constraint Name | CheckConstraint
Chk_SyStudent_LastInterestDate_OriginalStartDate | (([LastInterestDate] > [OriginalStartDate] or [LastInterestDate] is null and [OriginalStartDate] is null or [LastInterestDate] is null and [OriginalStartDate] is not null) and ((not([LastInterestDate] is not null and [OriginalStartDate] is null))))

syStudent Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

syStudent Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.Student | NO |  |  |
Physical (Microsoft SQL Server) dbo.syStudent | NO |  |  |

syStudent Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | Addresses_Affiliations
Logical | Applicant_Enroll
Logical | CourseRegistration
Logical | DegreePathway
Logical | Documents
Logical | FERPA
Logical | Grades/Attendance
Logical | Incidents
Logical | LedgerCard_Billing
Logical | PreviousEd_TransferCredits
Logical | Prospect
Logical | RefundCalculation
Logical | Refunds_Stipends
Logical | Revenue_GL_BankDeposit
Logical | SEVIS
Logical | StudentEnrollment
Logical | StudentJobPlacement
Logical | StudentPayments_Collections
Logical | StudentPlacementPreferences
Logical | SubsidiaryLedger
Logical | Tasks
Logical | TestScores
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records
Physical (Microsoft SQL Server) | System

syStudent Data Movement Rules

Name | Type | Rule Text/Value